NTISthis.com

Evidence Guide: ICTSAD501 - Model data objects

Student: __________________________________________________

Signature: _________________________________________________

Tips for gathering evidence to demonstrate your skills

The important thing to remember when gathering evidence is that the more evidence the better - that is, the more evidence you gather to demonstrate your skills, the more confident an assessor can be that you have learned the skills not just at one point in time, but are continuing to apply and develop those skills (as opposed to just learning for the test!). Furthermore, one piece of evidence that you collect will not usualy demonstrate all the required criteria for a unit of competency, whereas multiple overlapping pieces of evidence will usually do the trick!

From the Wiki University

 

ICTSAD501 - Model data objects

What evidence can you provide to prove your understanding of each of the following citeria?

Identify entities and relationships

  1. Analyse business data to understand operations
  2. Identify boundaries of the system
  3. Identify entities, attributes, data types and relationships of data
  4. Review business rules to determine impact
  5. Document relationships in an entity relationship diagram
Analyse business data to understand operations

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Identify boundaries of the system

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Identify entities, attributes, data types and relationships of data

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Review business rules to determine impact

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Document relationships in an entity relationship diagram

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Develop normalisation

  1. Identify suitable business data
  2. Undertake normalisation of business data and document results
  3. Compare normalisation results with entity relationship diagram
  4. Reconcile differences between data
Identify suitable business data

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Undertake normalisation of business data and document results

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Compare normalisation results with entity relationship diagram

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Reconcile differences between data

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Validate model

  1. Validate data model with client
  2. Resolve issues or recommendations
  3. Document completed data model
  4. Submit to client for final approval
Validate data model with client

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Resolve issues or recommendations

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Document completed data model

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Submit to client for final approval

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Assessed

Teacher: ___________________________________ Date: _________

Signature: ________________________________________________

Comments:

 

 

 

 

 

 

 

 

Instructions to Assessors

Evidence Guide

ELEMENT

PERFORMANCE CRITERIA

Elements describe the essential outcomes.

Performance criteria describe the performance needed to demonstrate achievement of the element.

1. Identify entities and relationships

1.1 Analyse business data to understand operations

1.2 Identify boundaries of the system

1.3 Identify entities, attributes, data types and relationships of data

1.4 Review business rules to determine impact

1.5 Document relationships in an entity relationship diagram

2. Develop normalisation

2.1 Identify suitable business data

2.2 Undertake normalisation of business data and document results

2.3 Compare normalisation results with entity relationship diagram

2.4 Reconcile differences between data

3. Validate model

3.1 Validate data model with client

3.2 Resolve issues or recommendations

3.3 Document completed data model

3.4 Submit to client for final approval

Required Skills and Knowledge

ELEMENT

PERFORMANCE CRITERIA

Elements describe the essential outcomes.

Performance criteria describe the performance needed to demonstrate achievement of the element.

1. Identify entities and relationships

1.1 Analyse business data to understand operations

1.2 Identify boundaries of the system

1.3 Identify entities, attributes, data types and relationships of data

1.4 Review business rules to determine impact

1.5 Document relationships in an entity relationship diagram

2. Develop normalisation

2.1 Identify suitable business data

2.2 Undertake normalisation of business data and document results

2.3 Compare normalisation results with entity relationship diagram

2.4 Reconcile differences between data

3. Validate model

3.1 Validate data model with client

3.2 Resolve issues or recommendations

3.3 Document completed data model

3.4 Submit to client for final approval

Evidence of the ability to:

document client business requirements

construct an entity relationship diagram

construct and document a data model

normalise the model

validate the model.

Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.

To complete the unit requirements safely and effectively, the individual must:

fully describe:

database identifiers and their impact on database usability

normalisation rules and processes

type hierarchies, including sub-types, super-types and root-types related to development of structured data types

validation procedures and processes

describe the function and features of:

an approach to data modelling, such as the entity-relationship model

keys, e.g. unique keys, composite keys, primary keys and primary index

time stamps related to the use of keys

user defined types, structured types, reference types and user defined functions

data types and their application

summarise the particular business domain.